Seward County Community College/Area Technical School
Course Syllabus

1. TITLE OF COURSE: CS1613 - Advanced Microcomputer Software Suites
2. COURSE DESCRIPTION: Three credit hours lecture. This course is designed to extend the student's basic knowledge of an office suites productivity package that includes word processing, spreadsheets, database management, and business presentations. Students will be challenged to create more advanced documents, databases, and presentations. This course will utilize the projects approach to learning. Prerequisite: OT 1113 Basic Keyboarding or equivalent and CS 1603, Microcomputer Software Suites or CS 1203, Introduction to Computer Concepts and Applications. For each unit of credit, a minimum of three hours per week with one of the hours for class and two hours for studying/preparation outside of class is expected.
3. PROGRAM AND/OR DEPARTMENT MISSION STATEMENT: The CIS Program will provide superior learning opportunities in the area of information technology, utilizing state-of-the-art technology, for both CIS majors and non CIS majors to enable all students to achieve their career and/or educational goals.
4. TEXTBOOK AND MATERIALS:
   • Textbook selected when course is offered.
5. SCCC/ATS OUTCOMES: Students who successfully complete this course will demonstrate the ability to do the following SCCC/ATS Outcomes:
   • Read with comprehension, be critical of what they read, and apply knowledge gained from their reading to broader issues of the day.
   • Communicate their ideas clearly and proficiently in writing and speaking, appropriately adjusting content and arrangement for varying audiences, purposes, and situations.
   • Solve problems using a variety of techniques and technologies.
   • Think critically by gathering facts, generating insights, analyzing data, and evaluating information.
   • Utilize current technology relevant to their respective disciplines.
6. COURSE OUTCOMES: Upon completion of the Advanced Microcomputer Software Suites course with 80% or higher mastery of course competencies, the student should be able to:
   • Demonstrate proficiency at an advanced level in word processing, spreadsheets, databases, and business presentations.
   • Demonstrate proficiency in integrating word processing, spreadsheets, databases, and business presentations with each other;
   • Utilize course information to prepare for proficiency certification exams.
   • Integrate the World Wide Web into the learning experience.
7. COURSE COMPETENCIES:
   • Word Processing
     • Create a title page with a border and clip art
     • Insert section breaks
     • Insert and existing document into an open document
     • Create headers and footers
     • Format and create a table chart
     • Draw a table
     • Create a watermark
     • Prepare form letters, mailing labels and envelopes
     • Create a newsletter using column formatting, color, and page borders
     • Create a newsletter for online viewing
   • Spreadsheets
     • Add borders to a range
     • Create cell names on two titles
     • Use a data table
     • Add a hyperlink to the worksheet
     • Create a database with computational fields
     • Sort a database
     • Use a data form to find records
     • Use auto filter to filter a database
     • Extract records
     • Create and format a template
     • Create a workbook from a template
     • Draw a 3-D cylinder Chart
     • Add comments and headers to a workbook
     • Change margins and print a workbook
     • Use find and replace commands
     • Consolidate data by linking workbooks
     • Integrate a workbook and a word processing document
   • Database
     • Create a report
     • Design a report
     • Create and use custom forms
     • Apply advanced form techniques
     • Use Wizards
     • Modify a report
     • Modify a form
     • Create and use macros
     • Integrate database, spreadsheet, and word processing
   • Presentations
     • Import text from another application
     • Insert and modify clip art
     • Customize graphical bullets using slide master
     • Create a table on a slide
     • Create an organizational chart
     • Add animation to slides
     • Change presentation template color scheme
     • Modify the footer on the title master
     • Add sound effects
     • Insert a spreadsheet chart into a slide
     • Add a word processing table to a slide
     • Add hyperlinks and embed fonts
     • Modify the presentation format
     • Add notes and print speaker notes
     • Collaborate a presentation with workgroups
   • Integration Projects
     • Integrate Excel, Word, PowerPoint and E-mail
     • Integrate Word, Word Art, and Access
     • Integrate Access into Word and Excel
8. COURSE OUTLINE:
   • Word Processing
     • Create a document with a table, chart, and watermark
     • Generate form letters, mailing labels, envelopes, and directories
     • Create a newsletter
     • Integrate form letters into email
   • Spreadsheet
     • Utilize financial functions, data tables, amortization schedules and hyperlinks
     • Create, sort, and query a worksheet database
     • Create templates and work with multiple worksheets and workbooks
     • Integrate a spreadsheet into a word document and web discussions
   • Database Management
     • Prepare reports, forms, and combo boxes
     • Enhance forms with OLE fields, hyperlinks, and sub forms
     • Create an application system using macros, wizards, and the switchboard manager
     • Integrate a database and spreadsheet and a database with word processing
   • Presentations Software
     • Create a slide show with visuals
     • Modify visuals and presentation formats
     • Integrate presentations with a workgroup
   • Integration Case Studies
   • Speech and Handwriting Recognition
   • MOUS Program
9. INSTRUCTIONAL METHODS:
   • Class discussions and demonstrations using the MS Office Course Presenter and assigned class projects.
   • Projects
   • Related readings and reports from printed or web sources.
   • Instructors will enforce the Academic Honor Code & Cheating Policy as set forth in the SCCC/ATS College Catalog. Students who fail to adhere to this policy will receive an F for the course final grade unless otherwise stated in the instructor’s course policies.
10. INSTRUCTIONAL AND RESOURCE MATERIALS:
    • Microsoft Office Teaching Tools
    • Microsoft Office Course Presenter
11. METHODS OF ASSESSMENT:
    • Project assignments
    • Written exercises
    • Daily applications that include online exercises to accompany class exercises
    • Case Studies involving integration of applications
    • Written and performance exams
    • SCCC/ATS Outcomes will be assessed using the above listed methods.
12. ADA STATEMENT
    • If you believe that you are entitled to special accommodations under the Americans with Disabilities Act, please contact the Dean of Student Services at 620-417-1016 or visit the office located in the Hobble Academic Building.    
    
    Revised 07/14